Parallel Implementation of Relational Database Management Systems Operations on a Multi-Core Network-Optimized System on a Chip

In a commercial Relational Database Management System (RDBMS), sort and join are the most demanding operations and it is quite beneficial to improve the performance of external sort and external join algorithms that handle large input data sizes. This paper proposes parallel implementations of multi-threaded external sort and external hash join algorithms to accelerate IBM DB2, one of leading RDBMSs, in sort and join operations using an IBM Power Edge of Network (IBM PowerEN TM ) Peripheral Component Interconnect Express (PCIe) card. The PowerEN PCIe card is used as an accelerator, and is based on PowerEN chip that runs at 2.3 GHz. The PowerEN chip consists of sixteen embedded 64-bit PowerPC cores, and each of sixteen cores supports four hardware threads. The main advantage of using features of PowerEN TM such as multithreaded multi-core, 10 GE Ethernet interface and hardware compression and decompression coprocessor is to execute the algorithms in parallel and reduce the size of data stored externally, and hence reduces the execution time as well as the size of external storage and bandwidth